package com.mobdev.notepad.shared;

import android.provider.BaseColumns;

public interface DBConstants extends BaseColumns
{
    /**
     * The default sort order for this table
     */
    public static final String DEFAULT_SORT_ORDER = "modified_on DESC";


    /*---------------------------------------------------------------*/
    /*                TABLE COLUMNS
    /*---------------------------------------------------------------*/


    /**
     * The id of this note on the server
     * <P>Type: TEXT</P>
     */
    public static final String REMOTE_ID = "helipad_id";

    /**
     * The title of the note
     * <P>Type: TEXT</P>
     */
    public static final String TITLE = "title";

    /**
     * The note itself
     * <P>Type: TEXT</P>
     */
    public static final String CONTENTS = "contents";

    /**
     * Note tags - space separated list.
     * <P>Type: TEXT</P>
     */
    public static final String TAGS = "tags";

    /**
     * The timestamp for when the note was created
     * <P>Type: INTEGER (long from System.curentTimeMillis())</P>
     */
    public static final String CREATED_ON = "created_on";

    /**
     * The timestamp for when the note was last modified
     * <P>Type: INTEGER (long from System.curentTimeMillis())</P>
     */
    public static final String MODIFIED_ON = "modified_on";

    /**
     * The timestamp for when the note was last synced with the server
     * <P>Type: INTEGER (int from System.curentTimeMillis()/1000)</P>
     */
    public static final String SYNCED_ON = "synced_on";

    /**
     * Whether the user has deleted this note from the phone.
     * <P>Type: 0 = false, 1 = created on phone, not yet uploaded, 2 = uploaded to server
     */
    public static final String NEW_NOTE_CREATED_ON_PHONE = "new_note_created_on_phone";

    /**
     * Whether the user has deleted this note from the phone.
     * <P>Type: BOOLEAN
     */
    public static final String DELETED_FROM_PHONE = "deleted_from_phone";


    /**
     * Whether to sync the note when there's a conflict.
     * <P>Type: BOOLEAN
     */
    public static final String DONT_SYNC_THIS_NOTE = "skip_sync_on_conflict2";


    /**
     * This note's id in the 3rd pty notepad (field name was kept "aknotepad_id" to avoid having to modified db on users' phones).
     * <P>Type: INTEGER
     */
    public static final String THIRD_PARTY_NOTEPAD_ID = "aknotepad_id";


}
